Power Prediction Analysis using Artificial Neural Network in MS Excel

In this study, an artificial neural network (ANN) based model for prediction of solar energy potential in Kuala Lumpur, Malaysia was developed. Standard multilayered, feed-forward, back-propagation neural networks were designed using Microsoft Excel (MS Excel). The meteorological data were acquired from Malaysia Meteorological Department. The data was consists of meteorological data from one station in Subang for period of 10 years (2003–2012) from were used for the training and testing the network. Parameter of month, sunshine duration, minimum temperature, maximum temperature, average temperature and relative humidity were used as inputs to the network, while the solar radiation was used as the output of the network. Simulation result shows that ANN potentially predicts solar radiation. Furthermore this prediction can contribute an enhancement of renewable energy development in Malaysia. Key-Words: Artificial Neural Network, Backpropagation, Multilayer Perceptron, Power Prediction, Solar radiation